// Licensed to the Apache Software Foundation (ASF) under one
// or more contributor license agreements.  See the NOTICE file
// distributed with this work for additional information
// regarding copyright ownership.  The ASF licenses this file
// to you under the Apache License, Version 2.0 (the
// "License"); you may not use this file except in compliance
// with the License.  You may obtain a copy of the License at
//
//   http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing,
// software distributed under the License is distributed on an
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
// KIND, either express or implied.  See the License for the
// specific language governing permissions and limitations
// under the License.


suite("test_cast_to_decimal32_9_3_from_str") {

    // This test case is generated from the correspoinding be UT test case,
    // update this case if the correspoinding be UT test case is updated,
    // e.g.: ../run-be-ut.sh --run --filter=FunctionCastToDecimalTest.* --gen_regression_case
    sql "drop table if exists test_cast_to_decimal32_9_3_from_str_17_nullable;"
    sql "create table test_cast_to_decimal32_9_3_from_str_17_nullable(f1 int, f2 string) properties('replication_num'='1');"
    sql """insert into test_cast_to_decimal32_9_3_from_str_17_nullable values (0, "0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(1, "-0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(2, "0"),(3, "1"),(4, "9"),(5, "99999"),(6, "900000"),(7, "900001"),(8, "999998"),(9, "999999"),(10, "0."),(11, "1."),(12, "9."),(13, "99999."),(14, "900000."),(15, "900001."),(16, "999998."),(17, "999999."),(18, "-0"),(19, "-1"),
      (20, "-9"),(21, "-99999"),(22, "-900000"),(23, "-900001"),(24, "-999998"),(25, "-999999"),(26, "-0."),(27, "-1."),(28, "-9."),(29, "-99999."),(30, "-900000."),(31, "-900001."),(32, "-999998."),(33, "-999999."),(34, ".0004"),(35, ".0014"),(36, ".0094"),(37, ".0994"),(38, ".9004"),(39, ".9014"),
      (40, ".9984"),(41, ".9994"),(42, ".0005"),(43, ".0015"),(44, ".0095"),(45, ".0995"),(46, ".9005"),(47, ".9015"),(48, ".9985"),(49, ".9994"),(50, "-.0004"),(51, "-.0014"),(52, "-.0094"),(53, "-.0994"),(54, "-.9004"),(55, "-.9014"),(56, "-.9984"),(57, "-.9994"),(58, "-.0005"),(59, "-.0015"),
      (60, "-.0095"),(61, "-.0995"),(62, "-.9005"),(63, "-.9015"),(64, "-.9985"),(65, "-.9994"),(66, "00004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(67, "00014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(68, "00094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(69, "00994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(70, "09004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(71, "09014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(72, "09984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(73, "09994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(74, "10004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(75, "10014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(76, "10094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(77, "10994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(78, "19004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(79, "19014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (80, "19984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(81, "19994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(82, "90004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(83, "90014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(84, "90094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(85, "90994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(86, "99004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(87, "99014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(88, "99984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(89, "99994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(90, "999990004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(91, "999990014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(92, "999990094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(93, "999990994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(94, "999999004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(95, "999999014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(96, "999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(97, "999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(98, "9000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(99, "9000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (100, "9000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(101, "9000000994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(102, "9000009004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(103, "9000009014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(104, "9000009984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(105, "9000009994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(106, "9000010004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(107, "9000010014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(108, "9000010094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(109, "9000010994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(110, "9000019004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(111, "9000019014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(112, "9000019984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(113, "9000019994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(114, "9999980004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(115, "9999980014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(116, "9999980094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(117, "9999980994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(118, "9999989004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(119, "9999989014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (120, "9999989984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(121, "9999989994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(122, "9999990004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(123, "9999990014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(124, "9999990094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(125, "9999990994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(126, "9999999004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(127, "9999999014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(128, "9999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(129, "9999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(130, "00005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(131, "00015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(132, "00095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(133, "00995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(134, "09005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(135, "09015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(136, "09985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(137, "09995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(138, "10005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(139, "10015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (140, "10095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(141, "10995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(142, "19005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(143, "19015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(144, "19985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(145, "19995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(146, "90005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(147, "90015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(148, "90095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(149, "90995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(150, "99005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(151, "99015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(152, "99985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(153, "99995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(154, "999990005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(155, "999990015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(156, "999990095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(157, "999990995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(158, "999999005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(159, "999999015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (160, "999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(161, "999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(162, "9000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(163, "9000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(164, "9000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(165, "9000000995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(166, "9000009005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(167, "9000009015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(168, "9000009985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(169, "9000009995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(170, "9000010005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(171, "9000010015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(172, "9000010095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(173, "9000010995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(174, "9000019005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(175, "9000019015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(176, "9000019985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(177, "9000019995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(178, "9999980005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(179, "9999980015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (180, "9999980095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(181, "9999980995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(182, "9999989005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(183, "9999989015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(184, "9999989985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(185, "9999989995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(186, "9999990004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(187, "9999990014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(188, "9999990094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(189, "9999990994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(190, "9999999004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(191, "9999999014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(192, "9999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(193, "9999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(194, "-00004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(195, "-00014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(196, "-00094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(197, "-00994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(198, "-09004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(199, "-09014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (200, "-09984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(201, "-09994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(202, "-10004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(203, "-10014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(204, "-10094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(205, "-10994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(206, "-19004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(207, "-19014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(208, "-19984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(209, "-19994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(210, "-90004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(211, "-90014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(212, "-90094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(213, "-90994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(214, "-99004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(215, "-99014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(216, "-99984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(217, "-99994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(218, "-999990004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(219, "-999990014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (220, "-999990094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(221, "-999990994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(222, "-999999004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(223, "-999999014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(224, "-999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(225, "-999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(226, "-9000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(227, "-9000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(228, "-9000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(229, "-9000000994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(230, "-9000009004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(231, "-9000009014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(232, "-9000009984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(233, "-9000009994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(234, "-9000010004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(235, "-9000010014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(236, "-9000010094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(237, "-9000010994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(238, "-9000019004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(239, "-9000019014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (240, "-9000019984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(241, "-9000019994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(242, "-9999980004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(243, "-9999980014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(244, "-9999980094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(245, "-9999980994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(246, "-9999989004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(247, "-9999989014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(248, "-9999989984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(249, "-9999989994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(250, "-9999990004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(251, "-9999990014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(252, "-9999990094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(253, "-9999990994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(254, "-9999999004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(255, "-9999999014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(256, "-9999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(257, "-9999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(258, "-00005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(259, "-00015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (260, "-00095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(261, "-00995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(262, "-09005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(263, "-09015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(264, "-09985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(265, "-09995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(266, "-10005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(267, "-10015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(268, "-10095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(269, "-10995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(270, "-19005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(271, "-19015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(272, "-19985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(273, "-19995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(274, "-90005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(275, "-90015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(276, "-90095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(277, "-90995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(278, "-99005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(279, "-99015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (280, "-99985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(281, "-99995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(282, "-999990005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(283, "-999990015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(284, "-999990095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(285, "-999990995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(286, "-999999005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(287, "-999999015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(288, "-999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(289, "-999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(290, "-9000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(291, "-9000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(292, "-9000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(293, "-9000000995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(294, "-9000009005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(295, "-9000009015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(296, "-9000009985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(297, "-9000009995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(298, "-9000010005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(299, "-9000010015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (300, "-9000010095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(301, "-9000010995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(302, "-9000019005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(303, "-9000019015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(304, "-9000019985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(305, "-9000019995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(306, "-9999980005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(307, "-9999980015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(308, "-9999980095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(309, "-9999980995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(310, "-9999989005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(311, "-9999989015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(312, "-9999989985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(313, "-9999989995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(314, "-9999990004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(315, "-9999990014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(316, "-9999990094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(317, "-9999990994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(318, "-9999999004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(319, "-9999999014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (320, "-9999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(321, "-9999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100")
      ,(322, null);
    """

    sql "set enable_strict_cast=true;"
    qt_sql_17_strict 'select f1, cast(f2 as decimalv3(9, 3)) from test_cast_to_decimal32_9_3_from_str_17_nullable order by 1;'

    sql "set enable_strict_cast=false;"
    qt_sql_17_non_strict 'select f1, cast(f2 as decimalv3(9, 3)) from test_cast_to_decimal32_9_3_from_str_17_nullable order by 1;'

    sql "drop table if exists test_cast_to_decimal32_9_3_from_str_17_not_nullable;"
    sql "create table test_cast_to_decimal32_9_3_from_str_17_not_nullable(f1 int, f2 string) properties('replication_num'='1');"
    sql """insert into test_cast_to_decimal32_9_3_from_str_17_not_nullable values (0, "0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(1, "-0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(2, "0"),(3, "1"),(4, "9"),(5, "99999"),(6, "900000"),(7, "900001"),(8, "999998"),(9, "999999"),(10, "0."),(11, "1."),(12, "9."),(13, "99999."),(14, "900000."),(15, "900001."),(16, "999998."),(17, "999999."),(18, "-0"),(19, "-1"),
      (20, "-9"),(21, "-99999"),(22, "-900000"),(23, "-900001"),(24, "-999998"),(25, "-999999"),(26, "-0."),(27, "-1."),(28, "-9."),(29, "-99999."),(30, "-900000."),(31, "-900001."),(32, "-999998."),(33, "-999999."),(34, ".0004"),(35, ".0014"),(36, ".0094"),(37, ".0994"),(38, ".9004"),(39, ".9014"),
      (40, ".9984"),(41, ".9994"),(42, ".0005"),(43, ".0015"),(44, ".0095"),(45, ".0995"),(46, ".9005"),(47, ".9015"),(48, ".9985"),(49, ".9994"),(50, "-.0004"),(51, "-.0014"),(52, "-.0094"),(53, "-.0994"),(54, "-.9004"),(55, "-.9014"),(56, "-.9984"),(57, "-.9994"),(58, "-.0005"),(59, "-.0015"),
      (60, "-.0095"),(61, "-.0995"),(62, "-.9005"),(63, "-.9015"),(64, "-.9985"),(65, "-.9994"),(66, "00004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(67, "00014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(68, "00094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(69, "00994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(70, "09004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(71, "09014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(72, "09984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(73, "09994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(74, "10004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(75, "10014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(76, "10094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(77, "10994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(78, "19004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(79, "19014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (80, "19984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(81, "19994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(82, "90004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(83, "90014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(84, "90094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(85, "90994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(86, "99004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(87, "99014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(88, "99984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(89, "99994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(90, "999990004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(91, "999990014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(92, "999990094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(93, "999990994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(94, "999999004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(95, "999999014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(96, "999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(97, "999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(98, "9000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(99, "9000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (100, "9000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(101, "9000000994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(102, "9000009004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(103, "9000009014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(104, "9000009984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(105, "9000009994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(106, "9000010004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(107, "9000010014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(108, "9000010094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(109, "9000010994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(110, "9000019004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(111, "9000019014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(112, "9000019984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(113, "9000019994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(114, "9999980004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(115, "9999980014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(116, "9999980094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(117, "9999980994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(118, "9999989004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(119, "9999989014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (120, "9999989984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(121, "9999989994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(122, "9999990004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(123, "9999990014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(124, "9999990094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(125, "9999990994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(126, "9999999004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(127, "9999999014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(128, "9999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(129, "9999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(130, "00005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(131, "00015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(132, "00095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(133, "00995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(134, "09005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(135, "09015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(136, "09985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(137, "09995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(138, "10005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(139, "10015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (140, "10095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(141, "10995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(142, "19005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(143, "19015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(144, "19985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(145, "19995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(146, "90005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(147, "90015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(148, "90095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(149, "90995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(150, "99005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(151, "99015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(152, "99985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(153, "99995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(154, "999990005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(155, "999990015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(156, "999990095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(157, "999990995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(158, "999999005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(159, "999999015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (160, "999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(161, "999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(162, "9000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(163, "9000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(164, "9000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(165, "9000000995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(166, "9000009005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(167, "9000009015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(168, "9000009985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(169, "9000009995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(170, "9000010005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(171, "9000010015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(172, "9000010095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(173, "9000010995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(174, "9000019005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(175, "9000019015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(176, "9000019985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(177, "9000019995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(178, "9999980005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(179, "9999980015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (180, "9999980095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(181, "9999980995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(182, "9999989005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(183, "9999989015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(184, "9999989985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(185, "9999989995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(186, "9999990004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(187, "9999990014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(188, "9999990094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(189, "9999990994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(190, "9999999004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(191, "9999999014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(192, "9999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(193, "9999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(194, "-00004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(195, "-00014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(196, "-00094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(197, "-00994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(198, "-09004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(199, "-09014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (200, "-09984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(201, "-09994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(202, "-10004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(203, "-10014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(204, "-10094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(205, "-10994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(206, "-19004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(207, "-19014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(208, "-19984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(209, "-19994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(210, "-90004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(211, "-90014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(212, "-90094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(213, "-90994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(214, "-99004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(215, "-99014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(216, "-99984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(217, "-99994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(218, "-999990004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(219, "-999990014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (220, "-999990094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(221, "-999990994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(222, "-999999004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(223, "-999999014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(224, "-999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(225, "-999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(226, "-9000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(227, "-9000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(228, "-9000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(229, "-9000000994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(230, "-9000009004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(231, "-9000009014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(232, "-9000009984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(233, "-9000009994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(234, "-9000010004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(235, "-9000010014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(236, "-9000010094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(237, "-9000010994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(238, "-9000019004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(239, "-9000019014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (240, "-9000019984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(241, "-9000019994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(242, "-9999980004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(243, "-9999980014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(244, "-9999980094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(245, "-9999980994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(246, "-9999989004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(247, "-9999989014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(248, "-9999989984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(249, "-9999989994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(250, "-9999990004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(251, "-9999990014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(252, "-9999990094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(253, "-9999990994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(254, "-9999999004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(255, "-9999999014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(256, "-9999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(257, "-9999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(258, "-00005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(259, "-00015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (260, "-00095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(261, "-00995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(262, "-09005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(263, "-09015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(264, "-09985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(265, "-09995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(266, "-10005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(267, "-10015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(268, "-10095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(269, "-10995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(270, "-19005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(271, "-19015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(272, "-19985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(273, "-19995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(274, "-90005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(275, "-90015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(276, "-90095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(277, "-90995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(278, "-99005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(279, "-99015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (280, "-99985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(281, "-99995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(282, "-999990005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(283, "-999990015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(284, "-999990095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(285, "-999990995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(286, "-999999005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(287, "-999999015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(288, "-999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(289, "-999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(290, "-9000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(291, "-9000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(292, "-9000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(293, "-9000000995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(294, "-9000009005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(295, "-9000009015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(296, "-9000009985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(297, "-9000009995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(298, "-9000010005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(299, "-9000010015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (300, "-9000010095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(301, "-9000010995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(302, "-9000019005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(303, "-9000019015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(304, "-9000019985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(305, "-9000019995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(306, "-9999980005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(307, "-9999980015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(308, "-9999980095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(309, "-9999980995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(310, "-9999989005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(311, "-9999989015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(312, "-9999989985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(313, "-9999989995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(314, "-9999990004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(315, "-9999990014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(316, "-9999990094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(317, "-9999990994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(318, "-9999999004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(319, "-9999999014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (320, "-9999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(321, "-9999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100");
    """

    sql "set enable_strict_cast=true;"
    qt_sql_17_strict 'select f1, cast(f2 as decimalv3(9, 3)) from test_cast_to_decimal32_9_3_from_str_17_not_nullable order by 1;'

    sql "set enable_strict_cast=false;"
    qt_sql_17_non_strict 'select f1, cast(f2 as decimalv3(9, 3)) from test_cast_to_decimal32_9_3_from_str_17_not_nullable order by 1;'

}